<report xmlns="http://developer.cognos.com/schemas/report/12.0/" useStyleVersion="10" expressionLocale="en-us">
				<modelPath>/content/folder[@name='Packages']/package[@name='Chargeback']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				<queries>
					<query name="Query1">
						<source>
							<model/>
						</source>
						<selection><dataItem name="Application" aggregate="none" rollupAggregate="none"><expression>[Advanced Data Mart].[Application Dimension].[Application]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Service Level" aggregate="none" rollupAggregate="none"><expression>[Advanced Data Mart].[Service Level Dimension].[Service Level]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Cost" aggregate="none" rollupAggregate="none"><expression>[Advanced Data Mart].[Service Level Dimension].[Cost]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="9" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Provisioned Capacity GB" aggregate="total"><expression>[Advanced Data Mart].[Current Chargeback Fact].[Provisioned Capacity GB]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="2" output="no"/><XMLAttribute name="RS_dataUsage" value="fact" output="no"/></XMLAttributes></dataItem><dataItem name="Provisioned Cost" aggregate="calculated"><expression>[Provisioned Capacity GB] * [Cost]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="9" output="no"/><XMLAttribute name="RS_relationalExpression" value="true" output="no"/></XMLAttributes></dataItem></selection>
					<detailFilters><detailFilter><filterExpression>[Advanced Data Mart].[Current Chargeback Fact].[Mapped By VM] = 0</filterExpression></detailFilter></detailFilters></query>
				<query name="Query2">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_capacity">
			<sqlText>select `application_dimension`.`name` as "Application_Name" , `service_level_dimension`.`name` as "Service_Level" , `service_level_dimension`.`cost` as "Cost" , sum(`coguda20`.`provisionedMB` / 1024) as "Provisioned_Capacity_GB" , min(`service_level_dimension`.`cost`) * sum((`coguda20`.`provisionedMB` / 1024)) as "Provisioned_Cost" 
 from `dwh_capacity`.`application_dimension` `application_dimension`, `dwh_capacity`.`service_level_dimension` `service_level_dimension`, `dwh_capacity`.`vm_capacity_fact` `coguda20`, `dwh_capacity`.`business_entity_dimension` `coguda21`, `dwh_capacity`.`date_dimension` `date_dimension`
 where ('EMPTY' = 'EMPTY' or `coguda20`.`businessEntityTk` &lt;&gt; 0 and (locate({fn CONCAT({fn CONCAT(N'&lt;', `coguda21`.`tenant`)}, N'&gt;')}, '&lt;&gt;') &gt; 0 or locate({fn CONCAT({fn CONCAT({fn CONCAT({fn CONCAT(N'&lt;', `coguda21`.`tenant`)}, N'.')}, `coguda21`.`lob`)}, N'&gt;')}, '&lt;&gt;') &gt; 0 or locate({fn CONCAT({fn CONCAT({fn CONCAT({fn CONCAT({fn CONCAT({fn CONCAT(N'&lt;', `coguda21`.`tenant`)}, N'.')}, `coguda21`.`lob`)}, N'.')}, `coguda21`.`businessUnit`)}, N'&gt;')}, '&lt;&gt;') &gt; 0 or locate({fn CONCAT({fn CONCAT({fn CONCAT({fn CONCAT({fn CONCAT({fn CONCAT({fn CONCAT({fn CONCAT(N'&lt;', `coguda21`.`tenant`)}, N'.')}, `coguda21`.`lob`)}, N'.')}, `coguda21`.`businessUnit`)}, N'.')}, `coguda21`.`project`)}, N'&gt;')}, '&lt;&gt;') &gt; 0)) and `coguda21`.`tk` = `coguda20`.`businessEntityTk` and `date_dimension`.`latest` = 1 and `application_dimension`.`tk` = `coguda20`.`applicationTk` and `date_dimension`.`tk` = `coguda20`.`dateTk` and `coguda20`.`serviceLevelTk` = `service_level_dimension`.`tk`
 group by `application_dimension`.`name`, `service_level_dimension`.`name`, `service_level_dimension`.`cost`</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application_Name"/><mdProjectedItem name="Service_Level"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Provisioned_Capacity_GB"/><mdProjectedItem name="Provisioned_Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application_Name"><expression>[SQL1].[Application_Name]</expression></dataItem><dataItem name="Service_Level"><expression>[SQL1].[Service_Level]</expression></dataItem><dataItem name="Cost"><expression>[SQL1].[Cost]</expression></dataItem><dataItem name="Provisioned_Capacity_GB"><expression>[SQL1].[Provisioned_Capacity_GB]</expression></dataItem><dataItem name="Provisioned_Cost"><expression>[SQL1].[Provisioned_Cost]</expression></dataItem></selection>
		</query><query name="Query3">
			<source>
				
			<queryOperation name="Union1" setOperation="UNION">
			<queryRefs><queryRef refQuery="Query1"/><queryRef refQuery="Query2"/></queryRefs>
			<projectionList autoGenerated="true"><queryItem name="Application"/><queryItem name="Service Level"/><queryItem name="Cost"/><queryItem name="Provisioned Capacity GB"/><queryItem name="Provisioned Cost"/></projectionList>
		</queryOperation></source>
			<selection><dataItem name="Application"><expression>[Union1].[Application]</expression></dataItem><dataItem name="Service Level"><expression>[Union1].[Service Level]</expression></dataItem><dataItem name="Cost"><expression>[Union1].[Cost]</expression></dataItem><dataItem name="Provisioned Capacity GB"><expression>[Union1].[Provisioned Capacity GB]</expression></dataItem><dataItem name="Provisioned Cost"><expression>[Union1].[Provisioned Cost]</expression></dataItem><dataItemListSummary refDataItem="Provisioned Capacity GB" aggregateMethod="total" name="Total(Provisioned Capacity GB)"/><dataItemListSummary refDataItem="Provisioned Cost" aggregateMethod="total" name="Total(Provisioned Cost)"/></selection>
		</query></queries>
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										<list refQuery="Query3" horizontalPagination="true" name="List1">
											
											
											
											<noDataHandler>
												<contents>
													<block>
														<contents>
															<textItem>
																<dataSource>
																	<staticValue>No Data Available</staticValue>
																</dataSource>
																<style>
																	<CSS value="padding:10px 18px;"/>
																</style>
															</textItem>
														</contents>
													</block>
												</contents>
											</noDataHandler>
											<style>
												<defaultStyles>
													<defaultStyle refStyle="ls"/>
												</defaultStyles>
												<CSS value="border-collapse:collapse"/>
											</style>
										<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Application"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Service Level"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Service Level"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Service Level"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Cost"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Provisioned Capacity GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Provisioned Capacity GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Provisioned Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Provisioned Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Application"><listFooter><listRows><listRow><rowCells><rowCell colSpan="3"><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Provisioned Capacity GB)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Provisioned Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><currencyFormat/></dataFormat></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="Service Level"/></listGroups><listOverallGroup><listFooter><listRows><listRow><rowCells><rowCell colSpan="3"><contents><textItem><dataSource><staticValue>Overall</staticValue></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="if"/></defaultStyles></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Provisioned Capacity GB)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Provisioned Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><dataFormat><currencyFormat/></dataFormat></style></rowCell></rowCells></listRow></listRows></listFooter></listOverallGroup></list>
									</contents>
								</pageBody>
								<pageHeader>
									<contents>
										<block><style><defaultStyles><defaultStyle refStyle="ta"/></defaultStyles></style>
											<contents>
												<textItem><style><defaultStyles><defaultStyle refStyle="tt"/></defaultStyles></style>
													<dataSource>
														<staticValue>Unified Chargeback</staticValue>
													</dataSource>
												</textItem>
											</contents>
										</block>
									</contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="ph"/>
										</defaultStyles>
										<CSS value="padding-bottom:10px"/>
									</style>
								</pageHeader>
								<pageFooter>
									<contents>
										<table>
											<tableRows>
												<tableRow>
													<tableCells>
														<tableCell>
															<contents>
																<date>
																	<style>
																		<dataFormat>
																			<dateFormat/>
																		</dataFormat>
																	</style>
																</date>
															</contents>
															<style>
																<CSS value="vertical-align:top;text-align:left;width:25%"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																<pageNumber/>
															</contents>
															<style>
																<CSS value="vertical-align:top;text-align:center;width:50%"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																<time>
																	<style>
																		<dataFormat>
																			<timeFormat/>
																		</dataFormat>
																	</style>
																</time>
															</contents>
															<style>
																<CSS value="vertical-align:top;text-align:right;width:25%"/>
															</style>
														</tableCell>
													</tableCells>
												</tableRow>
											</tableRows>
											<style>
												<defaultStyles>
													<defaultStyle refStyle="tb"/>
												</defaultStyles>
												<CSS value="border-collapse:collapse;width:100%"/>
											</style>
										</table>
									</contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/><XMLAttribute name="RS_modelModificationTime" value="2016-05-07T08:11:00.023Z" output="no"/></XMLAttributes><reportName>Unified Chargeback</reportName></report>